◀ Prev · Parts · Full · Next ▶

JDBC 4.1, is specified by a maintenance release 1 of JSR 221cite-ref-3[3] and is included in Java SE 7.cite-ref-4[4]

JDBC 4.2, is specified by a maintenance release 2 of JSR 221cite-ref-5[5] and is included in Java SE 8.cite-ref-6[6]

The latest version, JDBC 4.3, is specified by a maintenance release 3 of JSR 221cite-ref-7[7] and is included in Java SE 9.cite-ref-8[8]

| JDBC version | Java version | Release Type | Release date |

|---|---|---|---|

| 1.1 | JDK 1.1 | Main | 1997-02-19. [ 1 ] |

| 3.0 | J2SE 1.4 | Main | 2002-05-09 |

| 4.0 | Java SE 6 | Main | 2006-12-11 |

| 4.1 | Java SE 7 | Maintenance | 2011-10-13 |

| 4.2 | Java SE 8 | Maintenance | 2014-03-04 |

| 4.3 | Java SE 9 | Maintenance | 2017-09-21 |

| Oracle Datatype | setXXX() Methods |

|---|---|

| CHAR | setString() |

| VARCHAR2 | setString() |

| NUMBER | setBigDecimal() |

| NUMBER | setBoolean() |

| NUMBER | setByte() |

| NUMBER | setShort() |

| NUMBER | setInt() |

| NUMBER | setLong() |

| NUMBER | setFloat() |

| NUMBER | setDouble() |

| INTEGER | setInt() |

| FLOAT | setDouble() |

| CLOB | setClob() |

| BLOB | setBlob() |

| RAW | setBytes() |

| LONGRAW | setBytes() |

| DATE | setDate() |

| DATE | setTime() |

| DATE | setTimestamp() |

Since JDBC is mostly a collection of interface definitions and specifications, it allows multiple implementations of these interfaces to exist and be used by the same application at runtime. The API provides a mechanism for dynamically loading the correct Java packages and registering them with the JDBC Driver Manager (DriverManager). DriverManager is used as a Connection factory for creating JDBC connections.

◀ Prev · Parts · Full · Next ▶